<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateInterviewScoresTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('interview_scores', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('resume_id')->comment('简历表编号');
            $table->string('grooming')->nullable()->comment('仪容仪表');
            $table->string('ability_to_respond_and_express')->nullable()->comment('反应及表达能力');
            $table->string('relevant_working_experience')->nullable()->comment('相关工作经验');
            $table->string('degree_of_confidence')->nullable()->comment('自信程度');
            $table->string('professional_knowledge')->nullable()->comment('对专业知识的掌握程度');
            $table->string('degree_of_reaction')->nullable()->comment('所具经验与本公司业务的反应程度');
            $table->string('general_knowledge_of_the_company')->nullable()->comment('对本公司一般情况下的了解程度');
            $table->string('stability')->nullable()->comment('稳定性');
            $table->string('cooperative')->nullable()->comment('合作性');
            $table->string('willingness_to_work')->nullable()->comment('前来公司工作的意愿');
            $table->string('overall_rating')->nullable()->comment('总评');
            $table->integer('grades')->nullable()->default('1')->comment('档级1:1档(默认)2:2档3:3档4:其他');
            $table->string('rank')->nullable()->comment('职级');
            $table->string('salary_range')->nullable()->comment('薪资幅度');
            $table->string('opinion_of_personnel_department')->nullable()->comment('用人单位意见');
            $table->string('opinions_of_the_employing_department')->nullable()->comment('用人部门意见');
            $table->string('opinions_of_the_manager')->nullable()->comment('经理意见');
            $table->string('special_salary')->nullable()->comment('特殊薪资');
            $table->timestamps();
            $table->softDeletes();

        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('interview_scores');
    }
}
